package com.ysd.entity;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

import org.hibernate.annotations.ColumnDefault;
import org.springframework.format.annotation.DateTimeFormat;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelTarget;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor

@Entity
@ExcelTarget("20")
public class Member implements Serializable {
	//id
	@Id
	@GeneratedValue
	@Excel(name = "序号", width = 10)
	private Integer id;
	//会员卡号
	@Column(unique = true)
	@Excel(name = "会员卡号", orderNum = "0", width = 30)
	private String card_no;
	// 姓名
	@Excel(name = "会员名字", orderNum = "1")
	private String name;
	//性别
	@Excel(name = "性别", orderNum = "2")
	private String sex;
	// 身份
	@Excel(name = "身份", orderNum = "3")
	private Integer category;
	// 身份证号
	@Column(unique = true)
	@Excel(name = "身份证号", orderNum = "4",width = 30)
	private String card;
	// 系
	@Excel(name = "系", orderNum = "5")
	private String department;
	//专业
	@Excel(name = "专业", orderNum = "6")
	private String profession;
	//年级
	@Excel(name = "年级", orderNum = "7")
	private String grade;
	//电话
	@Excel(name = "手机号", orderNum = "8",width = 30)
	private String phone;
	//入会时间
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@Excel(name = "入会时间", orderNum = "9",width = 30)
	private String regdate;
	//资源使用状态
	@ColumnDefault("0")
	@Excel(name = "状态", orderNum = "10")
	private String status;
	//备注
	@Excel(name = "备注", orderNum = "11")
	private String remark;
	
}
